TillTenderCashDenominationCount

Entity Definition

Logical Name : TillTenderCashDenominationCount
Physical Name : LE_TL_TND_CSH_DNM_CNT

This entity applies to cash and provides a physical count of each tender media type and deonomination. For example it provides a count of the number of $10 notes, $5 notes, $.25 coins and the like in a till. This is four cash control purposes. In addition to the cash monetary value, this breaks down its composition as a set of currency denomination counts.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TillID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer TillTender(LE_TND_TL)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) TillTender(LE_TND_TL)
DenominationID (FK)(PK) An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, �50, etc. ID_DNM Identity integer Denomination(CO_DNM)
ISOCurrencyCode (FK)(PK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) Denomination(CO_DNM)
BalanceTypeCode Indicates the type of balance this count of currency denomination types refers to. Valid values are: COUNTED This is always based on an actual counted inventory of currency denomination types. CD_BLNC_TYP Code varchar(20)
CountedTenderMediaQuantity The quantity of a specific tender type, denomination bill or coin counted as part of tender settlement. Note that this is not the monetary value but a physical quantity of the money type and denomination. Examples 10 quarters ($2.50) the 10 represents the CountedTenderMediaQuantity. QU_CNT_MD_UN QuantityInteger integer

Relationships

Parent Entity Verb Phrase Child Entity
Denomination defines unit of currency for TillTenderCashDenominationCount
TillTender is composed of TillTenderCashDenominationCount

Logical Views containing TillTenderCashDenominationCount

Logical View
Logical 02400 - Control Transaction Macro View
Logical 03160 - Reporting - Store Operations - Till View